IFS 分析モデル:メンテナンス

この分析モデルは次の目的で使用されます:メンテナンス。Power BI の一部として予めパッケージ化され、提供される分析モデルのリストがあります。リストは、こちらを参照してください。

コンテンツ

用途/目的

主な分析シナリオは次のとおりです。

ファクト テーブル

モデル テーブル BI アクセスビュー 参照情報ソース 推奨アクセスタイプ
FACT TIME DIM_BI_TIME_BI DIM_BI_TIME オンライン
WORK TASK POSTINGS FACT_JT_TASK_ACCT_PQ_BI FACT_JT_TASK_ACCT_PQ オンライン
WO BUDGET FACT_WO_BUDGET_PQ_BI FACT_WO_BUDGET_PQ オンライン
WORK TASK ACTUALS SALES FACT_WO_TASK_ACT_SALES_PQ_BI FACT_WO_TASK_ACT_SALES_PQ オンライン
FACT WORK ORDER FACT_WORK_ORDER_PQ_BI FACT_WORK_ORDER_PQ オンライン
WORK TASK ACTUALS COST FACT_WORK_TASK_ACT_COST_PQ_BI FACT_WORK_TASK_ACT_COST_PQ オンライン
WORK TASK PLANNED FACT_WORK_TASK_PLANNED_PQ_BI FACT_WORK_TASK_PLANNED_PQ オンライン
FACT WORK TASK FACT_WORK_TASK_PQ_BI FACT_WORK_TASK_PQ オンライン
ASSET HEALTH MEASURES FACT_ASSET_HEALTH_BI FACT_ASSET_HEALTH オンライン
CURRENCY RATES FACT_CURRENCY_RATES_PQ_BI FACT_CURRENCY_RATES_PQ オンライン

対応する情報ソースについては以下に記載しています。情報ソースに関する詳しい情報は、情報ソースについてをご覧ください。

FACT_WO_TASK_ACTUALS_SALES
作業オーダの実際の売上情報ソースは、作業タスクに関連する収益に基づいています。この情報ソースには、時間のレポート、材料の問題、ツールの使用、収益額などの費用に関するトランザクションが含まれます。

FACT_WORK_TASK_ACTUALS_COST
作業タスクの実際のコスト情報ソースは、作業タスクに関連するコストに基づいています。この情報ソースには、経費、外部、固定価格、材料、人員、ツール/機器のトランザクションが含まれます。

FACT_WO_BUDGET
作業オーダの予算情報ソースは、作業オーダー書に手入力した予算コストと収益に基づいています。分析には主に作業オーダの実績の情報ソースと組み合わせて使用​​する必要があります。

FACT_WORK_TASK_PLANNED
作業のタスク計画に関する情報ソースは、作業タスクの計画ラインに基づいています。分析には主に作業タスクの実際の情報ソースと組み合わせて使用​​する必要があります。

FACT_WORK_ORDERS
作業オーダの情報ソースは 「IFS\作業オーダ」に基づいています。この情報ソースには、すべてのステータスの作業オーダ (アクティブな作業オーダと履歴作業オーダの両方)、および作業要求と障害レポートが含まれます。

FACT_WORK_TASK
作業オーダー書には、1 つ以上の作業タスクを接続できます。作業タスクは、障害レポートやサービス要求などによって開始された作業を実行するエンティティです。IFS/サービス管理を使用することで、実行されたメンテナンス アクティビティが作業タスクを通じて顧客に報告、監視、請求できます。

FACT_JT_TASK_ACCOUNTING
作業タスク会計情報ソースは、作業タスクに関連する実際のトランザクションに基づいています。作業オーダ、作業タスク、作業タスクのトランザクション、作業タスク コストのデータを組み合わせます。

ディメンション テーブル

モデル テーブル BI アクセスビュー 参照情報ソース 推奨アクセスタイプ
ACCOUNT DIM_ACCOUNT_BI DIM_ACCOUNT オンライン
ACTIVITY DIM_ACTIVITY_BI DIM_ACTIVITY オンライン
CAUSE DIM_CAUSE_BI DIM_CAUSE オンライン
CLASS DIM_CLASS_BI DIM_CLASS オンライン
CANCEL TASK CAUSE DIM_CANCEL_TASK_CAUSE_BI DIM_CANCEL_TASK_CAUSE オンライン
CODE B DIM_CODE_B_BI DIM_CODE_B オンライン
CODE C DIM_CODE_C_BI DIM_CODE_C オンライン
CODE D DIM_CODE_D_BI DIM_CODE_D オンライン
CODE E DIM_CODE_E_BI DIM_CODE_E オンライン
CODE F DIM_CODE_F_BI DIM_CODE_F オンライン
CODE G DIM_CODE_G_BI DIM_CODE_G オンライン
CODE H DIM_CODE_H_BI DIM_CODE_H オンライン
CODE I DIM_CODE_I_BI DIM_CODE_I オンライン
CODE J DIM_CODE_J_BI DIM_CODE_J オンライン
COMPANY DIM_COMPANY_BI DIM_COMPANY オンライン
COMPATIBLE UNIT DIM_CMPUNT_COMPATIBLE_UNIT_BI DIM_CMPUNT_COMPATIBLE_UNIT オンライン
CUSTOMER DIM_CUSTOMER_BI DIM_CUSTOMER オンライン
DISCOVERY DIM_DISCOVERY_BI DIM_DISCOVERY オンライン
EVENT DIM_EVENT_BI DIM_EVENT オンライン
FAILING COMPONENT DIM_FAILING_COMPONENT_BI DIM_FAILING_COMPONENT オンライン
FAULT TYPE DIM_FAULT_TYPE_BI DIM_FAULT_TYPE オンライン
ITEM CLASS FUNCTION DIM_ITEM_CLASS_FUNCTION_BI DIM_ITEM_CLASS_FUNCTION オンライン
ITEM CLASS SOURCE DIM_IC_SOURCE_TYPE_BI DIM_IC_SOURCE_TYPE オンライン
LINEAR ASSET DIM_LINAST_LINEAR_ASSET_PQ_BI DIM_LINAST_LINEAR_ASSET_PQ オンライン
OPERATIONAL STATUS DIM_OPERATIONAL_STATUS_BI DIM_OPERATIONAL_STATUS オンライン
ORGANIZATION DIM_ORGANIZATION_BI DIM_ORGANIZATION オンライン
PERFORMED ACTION DIM_PERFORMED_ACTION_BI DIM_PERFORMED_ACTION オンライン
PM GROUP DIM_PM_GROUP_BI DIM_PM_GROUP オンライン
PRIORITY DIM_PRIORITY_BI DIM_PRIORITY オンライン
PROJECT DIM_PROJECT_BI DIM_PROJECT オンライン
PROJECT PROGRAM DIM_PROJECT_PROGRAM_BI DIM_PROJECT_PROGRAM オンライン
REPORTING CURRENCY FACT_CURRENCY_RATES_BI,LUP_REP_CURR_RATE_TYPE_TC,DIM_CURRENCY_CODE_BI,DIM_CURRENCY_RATE_TYPE_BI DIM_REPORTING_CURRENCY オンライン
REPORTING PERIOD DIM_REPORTING_PERIOD_PQ_BI DIM_REPORTING_PERIOD_PQ オンライン
SALES PART DIM_SALES_PART_BI DIM_SALES_PART オンライン
SERVICE CONTRACT DIM_SERVICE_CONTRACT_LINE_BI DIM_SERVICE_CONTRACT_LINE オンライン
SITE DIM_SITE_BI DIM_SITE オンライン
SLA ORDER DIM_SLA_ORDER_BI DIM_SLA_ORDER オンライン
SLA ORDER LINE DIM_SLA_ORDER_LINE_BI DIM_SLA_ORDER_LINE オンライン
SOURCE CONNECTION DIM_JT_CONNECTED_OBJECT_BI DIM_JT_CONNECTED_OBJECT オンライン
SOURCE OBJECT DIM_SOURCE_OBJECT_BI DIM_SOURCE_OBJECT オンライン
SUPPLIER DIM_SUPPLIER_BI DIM_SUPPLIER オンライン
SYMPTOM DIM_SYMPTOM_BI DIM_SYMPTOM オンライン
TASK ACCOUNTING TYPE DIM_TASK_ACCOUNTING_TYPE_BI DIM_TASK_ACCOUNTING_TYPE オンライン
TIME TYPE DIM_TIME_TYPE_BI DIM_TIME_TYPE オンライン
TRANSACTION TYPE DIM_TRANSACTION_TYPE_BI DIM_TRANSACTION_TYPE オンライン
VIM SERIAL DIM_VIM_SERIAL_BI DIM_VIM_SERIAL オンライン
WO CONNECTION TYPE DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE オンライン
WORK ORDER DIM_WORK_ORDER_BI DIM_WORK_ORDER オンライン
WORK STAGE DIM_WORK_STAGE_BI DIM_WORK_STAGE オンライン
WORK TASK DIM_WORK_TASK_BI DIM_WORK_TASK オンライン
WORK TYPE DIM_WORK_TYPE_BI DIM_WORK_TYPE オンライン
WORK TYPE CATEGORY DIM_WORK_TYPE_CATEGORY_BI DIM_WORK_TYPE_CATEGORY オンライン
CRITICALITY DIM_CRITICALITY_BI DIM_CRITICALITY オンライン
WO COST TYPE DIM_WO_COST_TYPE_BI DIM_WO_COST_TYPE オンライン
ITEM CLASS DIM_ITEM_CLASS_PQ_BI DIM_ITEM_CLASS_PQ オンライン
REPORTING DATE DIM_BI_TIME_BI DIM_BI_TIME オンライン
SUB PROJECT DIM_SUB_PROJECT_PQ_BI DIM_SUB_PROJECT_PQ オンライン
WT CONNECTION TYPE REPORTED DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE オンライン
WT CONNECTION TYPE ACTUAL DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE オンライン
伝票日付 DIM_BI_TIME_BI DIM_BI_TIME オンライン
SOURCE SITE DIM_SITE_BI DIM_SITE オンライン
SLA 最終開始日 DIM_BI_TIME_BI DIM_BI_TIME オンライン
SLA 最終終了日 DIM_BI_TIME_BI DIM_BI_TIME オンライン
必須開始日 DIM_BI_TIME_BI DIM_BI_TIME オンライン
必須終了日 DIM_BI_TIME_BI DIM_BI_TIME オンライン
REPORTED OBJECT SITE DIM_SITE_BI DIM_SITE オンライン
PLANNED START DATE DIM_BI_TIME_BI DIM_BI_TIME オンライン
計画終了日 DIM_BI_TIME_BI DIM_BI_TIME オンライン
計画日 DIM_BI_TIME_BI DIM_BI_TIME オンライン
ORGANIZATION SITE DIM_SITE_BI DIM_SITE オンライン
CREATED DATE DIM_BI_TIME_BI DIM_BI_TIME オンライン
ACTUAL START DATE DIM_BI_TIME_BI DIM_BI_TIME オンライン
ACTUAL OBJECT SITE DIM_SITE_BI DIM_SITE オンライン
ACTUAL FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME オンライン
ACTUAL EQUIPMENT OBJECT DIM_EQUIPMENT_OBJECT_PQ_BI DIM_EQUIPMENT_OBJECT_PQ オンライン
REPORTED EQUIPMENT OBJECT DIM_EQUIPMENT_OBJECT_BI DIM_EQUIPMENT_OBJECT オンライン
ASSET TYPE DIM_ASSET_TYPE_BI DIM_ASSET_TYPE オンライン
ASSET HEALTH HISTORY FACT_ASSET_HEALTH_HISTORY_BI FACT_ASSET_HEALTH_HISTORY オンライン
ASSET HEALTH INDI HST FACT_ASSET_HEALTH_INDI_HST_BI FACT_ASSET_HEALTH_INDI_HST オンライン
ASSET HEALTH INDICATOR FACT_ASSET_HEALTH_INDICATOR_BI FACT_ASSET_HEALTH_INDICATOR オンライン
ASSET HEALTH LEVEL FACT_ASSET_HEALTH_LEVEL_BI FACT_ASSET_HEALTH_LEVEL オンライン
ASSET HEALTH FACT_ASSET_HEALTH_BI FACT_ASSET_HEALTH オンライン
ASSET HEALTH DIMENSION DIM_ASSET_HEALTH_BI DIM_ASSET_HEALTH オンライン
ASSET HEALTH INDICATOR DIMENSION DIM_ASSET_HEALTH_INDICATOR_BI DIM_ASSET_HEALTH_INDICATOR オンライン
COLOR LEVEL 該当なし EAM_COLOR_LEVEL オンライン
HEALTH LEVEL 該当なし EAM_HEALTH_LEVEL オンライン

コンフィギュレーション

該当なし

制限事項

該当なし

関係

次の表は、モデル内のテーブルと列の関係を示しています。

関係:テーブル (列) - テーブル (列)
CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID)
CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID)
FACT TIME (ID) - ACTUAL FINISH DATE (ID)
FACT TIME (ID) - ACTUAL START DATE (ID)
FACT TIME (ID) - CREATED DATE (ID)
FACT TIME (ID) - PLANNED DATE (ID)
FACT TIME (ID) - PLANNED FINISH DATE (ID)
FACT TIME (ID) - PLANNED START DATE (ID)
FACT TIME (ID) - REPORTING DATE (ID)
FACT TIME (ID) - REQUIRED FINISH DATE (ID)
FACT TIME (ID) - REQUIRED START DATE (ID)
FACT TIME (ID) - SLA LATEST FINISH DATE (ID)
FACT TIME (ID) - SLA LATEST START DATE (ID)
FACT TIME (ID) - VOUCHER DATE (ID)
FACT WORK ORDER (Dim_Activity_ID) - ACTIVITY (ID)
FACT WORK ORDER (DIM_COMPANY_ID) - COMPANY (ID)
FACT WORK ORDER (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID)
FACT WORK ORDER (Dim_Customer_ID) - CUSTOMER (ID)
FACT WORK ORDER (Dim_Date_Actual_Complete_ID) - ACTUAL FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
FACT WORK ORDER (Dim_Date_Created_ID) - CREATED DATE (ID)
FACT WORK ORDER (Dim_Date_Planned_Complete_ID) - PLANNED FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
FACT WORK ORDER (Dim_Date_Required_Complete_ID) - REQUIRED FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Required_Start_ID) - REQUIRED START DATE (ID)
FACT WORK ORDER (Dim_Discovery_ID) - DISCOVERY (ID)
FACT WORK ORDER (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
FACT WORK ORDER (Dim_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID)
FACT WORK ORDER (Dim_Event_ID) - EVENT (ID)
FACT WORK ORDER (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
FACT WORK ORDER (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
FACT WORK ORDER (DIM_ORGANIZATION_ID) - ORGANIZATION (ID)
FACT WORK ORDER (Dim_Priority_ID) - PRIORITY (ID)
FACT WORK ORDER (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
FACT WORK ORDER (Dim_Project_ID) - PROJECT (ID)
FACT WORK ORDER (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
FACT WORK ORDER (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
FACT WORK ORDER (DIM_SITE_ID) - SITE (ID)
FACT WORK ORDER (Dim_Sla_Order_No) - SLA ORDER (ID)
FACT WORK ORDER (Dim_Sub_Project_ID) - SUB PROJECT (ID)
FACT WORK ORDER (Dim_Supplier_ID) - SUPPLIER (ID)
FACT WORK ORDER (Dim_Symptom_ID) - SYMPTOM (ID)
FACT WORK ORDER (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
FACT WORK ORDER (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
FACT WORK ORDER (DIM_WORK_ORDER_ID) - WORK ORDER (ID)
FACT WORK ORDER (DIM_WORK_TYPE_CATEGORY_ID) - WORK TYPE CATEGORY (ID)
FACT WORK ORDER (DIM_WORK_TYPE_ID) - WORK TYPE (ID)
FACT WORK TASK (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
FACT WORK TASK (Dim_Activity_ID) - ACTIVITY (ID)
FACT WORK TASK (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
FACT WORK TASK (Dim_Cause_ID) - CAUSE (ID)
FACT WORK TASK (Dim_Class_ID) - CLASS (ID)
FACT WORK TASK (Dim_Company_ID) - COMPANY (ID)
FACT WORK TASK (Dim_Customer_ID) - CUSTOMER (ID)
FACT WORK TASK (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
FACT WORK TASK (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
FACT WORK TASK (Dim_Date_Reported_ID) - REPORTING DATE (ID)
FACT WORK TASK (Dim_Discovery_ID) - DISCOVERY (ID)
FACT WORK TASK (Dim_Event_ID) - EVENT (ID)
FACT WORK TASK (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
FACT WORK TASK (Dim_Fault_Type_ID) - FAULT TYPE (ID)
FACT WORK TASK (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
FACT WORK TASK (Dim_Item_Class_ID) - ITEM CLASS (ID)
FACT WORK TASK (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
FACT WORK TASK (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
FACT WORK TASK (Dim_Organization_ID) - ORGANIZATION (ID)
FACT WORK TASK (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
FACT WORK TASK (Dim_PM_Group_ID) - PM GROUP (ID)
FACT WORK TASK (Dim_Priority_ID) - PRIORITY (ID)
FACT WORK TASK (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
FACT WORK TASK (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
FACT WORK TASK (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
FACT WORK TASK (Dim_Site_ID) - SITE (ID)
FACT WORK TASK (Dim_Site_ID) - SOURCE SITE (ID)
FACT WORK TASK (Dim_SLA_ORDER_Line_ID) - SLA ORDER LINE (ID)
FACT WORK TASK (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
FACT WORK TASK (Dim_Supplier_ID) - SUPPLIER (ID)
FACT WORK TASK (Dim_Symptom_ID) - SYMPTOM (ID)
FACT WORK TASK (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
FACT WORK TASK (Dim_Work_Order_ID) - WORK ORDER (ID)
FACT WORK TASK (Dim_Work_Stage_ID) - WORK STAGE (ID)
FACT WORK TASK (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
FACT WORK TASK (Dim_Work_Type_ID) - WORK TYPE (ID)
WO BUDGET (Dim_Activity_ID) - ACTIVITY (ID)
WO BUDGET (Dim_Company_ID) - COMPANY (ID)
WO BUDGET (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID)
WO BUDGET (Dim_Cost_Type_ID) - WO COST TYPE (ID)
WO BUDGET (Dim_Customer_ID) - CUSTOMER (ID)
WO BUDGET (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID)
WO BUDGET (Dim_Date_Required_Compl_ID) - REQUIRED FINISH DATE (ID)
WO BUDGET (Dim_Discovery_ID) - DISCOVERY (ID)
WO BUDGET (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WO BUDGET (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
WO BUDGET (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WO BUDGET (Dim_Organization_ID) - ORGANIZATION (ID)
WO BUDGET (Dim_Priority_ID) - PRIORITY (ID)
WO BUDGET (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WO BUDGET (Dim_Project_ID) - PROJECT (ID)
WO BUDGET (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
WO BUDGET (Dim_Site_ID) - SITE (ID)
WO BUDGET (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WO BUDGET (Dim_Supplier_ID) - SUPPLIER (ID)
WO BUDGET (Dim_Symptom_ID) - SYMPTOM (ID)
WO BUDGET (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
WO BUDGET (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WO BUDGET (Dim_Work_Order_ID) - WORK ORDER (ID)
WO BUDGET (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WO BUDGET (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK ACTUALS COST (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS COST (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK ACTUALS COST (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK ACTUALS COST (Dim_Cause_ID) - CAUSE (ID)
WORK TASK ACTUALS COST (Dim_Class_ID) - CLASS (ID)
WORK TASK ACTUALS COST (Dim_Company_ID) - COMPANY (ID)
WORK TASK ACTUALS COST (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK ACTUALS COST (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Reported_ID) - REPORTING DATE (ID)
WORK TASK ACTUALS COST (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK ACTUALS COST (Dim_Event_ID) - EVENT (ID)
WORK TASK ACTUALS COST (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK ACTUALS COST (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK ACTUALS COST (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK ACTUALS COST (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK ACTUALS COST (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK ACTUALS COST (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK ACTUALS COST (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK ACTUALS COST (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK ACTUALS COST (Dim_Project_ID) - PROJECT (ID)
WORK TASK ACTUALS COST (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK ACTUALS COST (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID)
WORK TASK ACTUALS COST (Dim_Site_ID) - SITE (ID)
WORK TASK ACTUALS COST (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK ACTUALS COST (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK ACTUALS COST (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK ACTUALS COST (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK ACTUALS COST (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK ACTUALS COST (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
WORK TASK ACTUALS COST (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK ACTUALS COST (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK ACTUALS COST (Dim_Work_Task_ID) - WORK TASK (ID)
WORK TASK ACTUALS COST (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK ACTUALS COST (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK ACTUALS SALES (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK ACTUALS SALES (Dim_Cause_ID) - CAUSE (ID)
WORK TASK ACTUALS SALES (Dim_Class_ID) - CLASS (ID)
WORK TASK ACTUALS SALES (Dim_Company_ID) - COMPANY (ID)
WORK TASK ACTUALS SALES (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK ACTUALS SALES (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - REPORTING DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST FINISH DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST START DATE (ID)
WORK TASK ACTUALS SALES (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK ACTUALS SALES (Dim_Event_ID) - EVENT (ID)
WORK TASK ACTUALS SALES (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK ACTUALS SALES (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK ACTUALS SALES (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK ACTUALS SALES (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK ACTUALS SALES (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK ACTUALS SALES (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK ACTUALS SALES (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK ACTUALS SALES (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK ACTUALS SALES (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK ACTUALS SALES (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - SITE (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - SOURCE SITE (ID)
WORK TASK ACTUALS SALES (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK ACTUALS SALES (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK ACTUALS SALES (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
WORK TASK ACTUALS SALES (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK ACTUALS SALES (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK ACTUALS SALES (Dim_Work_Task_ID) - WORK TASK (ID)
WORK TASK ACTUALS SALES (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK ACTUALS SALES (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK PLANNED (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK PLANNED (Dim_Cause_ID) - CAUSE (ID)
WORK TASK PLANNED (Dim_Class_ID) - CLASS (ID)
WORK TASK PLANNED (Dim_Company_ID) - COMPANY (ID)
WORK TASK PLANNED (Dim_Cost_Type_ID) - WO COST TYPE (ID)
WORK TASK PLANNED (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK PLANNED (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK PLANNED (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK PLANNED (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK PLANNED (Dim_Event_ID) - EVENT (ID)
WORK TASK PLANNED (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK PLANNED (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
WORK TASK PLANNED (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK PLANNED (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK PLANNED (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK PLANNED (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK PLANNED (Dim_Proj_Program_Id) - PROJECT PROGRAM (ID)
WORK TASK PLANNED (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
WORK TASK PLANNED (Dim_Site_ID) - SITE (ID)
WORK TASK PLANNED (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK PLANNED (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK PLANNED (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK PLANNED (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK PLANNED (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
WORK TASK PLANNED (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK PLANNED (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK PLANNED (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK POSTINGS (Dim_Account_ID) - ACCOUNT (ID)
WORK TASK POSTINGS (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK POSTINGS (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK POSTINGS (Dim_Cause_ID) - CAUSE (ID)
WORK TASK POSTINGS (Dim_Class_ID) - CLASS (ID)
WORK TASK POSTINGS (Dim_Code_B_ID) - CODE B (ID)
WORK TASK POSTINGS (Dim_Code_C_ID) - CODE C (ID)
WORK TASK POSTINGS (Dim_Code_D_ID) - CODE D (ID)
WORK TASK POSTINGS (Dim_Code_E_ID) - CODE E (ID)
WORK TASK POSTINGS (Dim_Code_F_ID) - CODE F (ID)
WORK TASK POSTINGS (Dim_Code_G_ID) - CODE G (ID)
WORK TASK POSTINGS (Dim_Code_H_ID) - CODE H (ID)
WORK TASK POSTINGS (Dim_Code_I_ID) - CODE I (ID)
WORK TASK POSTINGS (Dim_Code_J_ID) - CODE J (ID)
WORK TASK POSTINGS (Dim_Company_ID) - COMPANY (ID)
WORK TASK POSTINGS (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK POSTINGS (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
WORK TASK POSTINGS (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID)
WORK TASK POSTINGS (Dim_Date_Latest_Finish_ID) - REQUIRED FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK POSTINGS (Dim_Date_SLA_Latest_Finish_ID) - SLA LATEST FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_SLA_Latest_Start_Id) - SLA LATEST START DATE (ID)
WORK TASK POSTINGS (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK POSTINGS (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK POSTINGS (Dim_Event_ID) - EVENT (ID)
WORK TASK POSTINGS (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK POSTINGS (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK POSTINGS (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK POSTINGS (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - SOURCE CONNECTION (ID)
WORK TASK POSTINGS (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK POSTINGS (Dim_Organisation_Site_ID) - ORGANIZATION SITE (ID)
WORK TASK POSTINGS (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK POSTINGS (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK POSTINGS (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK POSTINGS (Dim_Posting_Type_ID) - TASK ACCOUNTING TYPE (ID)
WORK TASK POSTINGS (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK POSTINGS (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK POSTINGS (Dim_Project_ID) - PROJECT (ID)
WORK TASK POSTINGS (Dim_Rep_Mch_Ref_ID) - REPORTED EQUIPMENT OBJECT (ID)
WORK TASK POSTINGS (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK POSTINGS (Dim_Reporting_Date_Id) - REPORTING DATE (ID)
WORK TASK POSTINGS (Dim_Rpd_Company_Period_ID) - REPORTING PERIOD (Company-Date)
WORK TASK POSTINGS (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID)
WORK TASK POSTINGS (Dim_Site_ID) - SITE (ID)
WORK TASK POSTINGS (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK POSTINGS (Dim_Source_Site_ID) - SOURCE SITE (ID)
WORK TASK POSTINGS (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK POSTINGS (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK POSTINGS (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK POSTINGS (Dim_Time_Type_ID) - TIME TYPE (ID)
WORK TASK POSTINGS (Dim_Transaction_Type_ID) - TRANSACTION TYPE (ID)
WORK TASK POSTINGS (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WORK TASK POSTINGS (Dim_WO_Cost_Type_ID) - WO COST TYPE (ID)
WORK TASK POSTINGS (Dim_Work_Order_No_Id) - WORK ORDER (ID)
WORK TASK POSTINGS (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK POSTINGS (Dim_Work_Task_Seq_ID) - WORK TASK (ID)
WORK TASK POSTINGS (Dim_Work_Type_Cat_ID) - WORK TYPE CATEGORY (ID)
WORK TASK POSTINGS (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK PLANNED (Dim_Criticality_ID) - CRITICALITY (ID)
ASSET HEALTH (Dim_Company_Id) - COMPANY (ID)
ASSET HEALTH (Dim_Site_Id) - SITE (ID)
WORK TASK ACTUALS COST (Dim_Site_ID) - ACTUAL OBJECT SITE (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - ACTUAL OBJECT SITE (ID)
WORK TASK POSTINGS (Dim_Actual_Obj_Site_ID) - ACTUAL OBJECT SITE (ID)
ASSET HEALTH INDI HST (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH HISTORY (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH LEVEL (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH INDICATOR (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH HISTORY (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH INDI HST (Dim_Asset_Health_Indicator) - ASSET HEALTH INDICATOR DIMENSION (ID)
ASSET HEALTH INDICATOR (ID) - ASSET HEALTH INDICATOR DIMENSION (ID)
ASSET HEALTH INDI HST (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH LEVEL (レベル) - COLOR LEVEL (説明)
ASSET HEALTH (資産健全性レベル) - COLOR LEVEL (説明)